Character numeric type:
Char, varchar, long varchar
Nchar, nvarchar, long nvarchar
-Compatible data types are implemented through domains: sysname (varchar (30), text (long varchar domain), ntext (long nvarchar domain), and XML (long
? DB2Introduction to System tables in DB2DB2 command line Processor (DB2 CLP) is available in all DB2 products and can be used to run DB2 commands, operating system commands, or SQL statements.When the DB2 database is created, DB2 will create some
When you create a table or declare a local variable, you must use the Sybase system predefined type.
1. Character type
Char (n) VarChar (n)
2. Numeric type
Integer type--integer SmallInt TinyInt
Floating-point type--real float number[p,s]
Mysql5.0 Stored procedure Stored routines require the proc table in the mysql database. (mysql. proc)
Tips:
1. before creating a stored procedure, use delimiter $ to define the statement terminator. after creation, restore the statement terminator
The correspondence between Jdbctype and Javatype
Java.sql.Types value
Java type
IBM DB2
Oracle
Sybase
Sql
Informix
IBM Content Manager
BIGINT
Java.lang.long
BIGINT
Transfer from http://blog.csdn.net/haofeng82/article/details/34857991
Java.sql.Types value
Java type
IBM DB2
Oracle
Sybase
Sql
Informix
IBM Content Manager
BIGINT
MySQL Database Basics (iii)--sql Language I. Introduction to SQL 1. Introduction to SQL languageSQL is a Structured Query language (structured Query Language), which is the standard computer language for accessing and working with databases.The
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.